EDA (RTC Severity)

Contents:

Part-1: Univariate Analysis

⬆️TOP⬆️

Contents:

⬆️TOP⬆️

Feature: 1st_Road_Class and 1st_Road_Number
Observations:

⬆️TOP⬆️

Feature: 2nd_Road_Class and 2nd_Road_Number
Observations:

⬆️TOP⬆️

Feature: Carriageway_Hazards

Checking if the values are None or missing

Observations:

👉 Filling the missing values (29) with mode (None)

⬆️TOP⬆️

Feature: Date

Task-1:

Converting Date column from Object to Datetime

Task-2:

Adding extra 2 features to the dataset (Day and Month)

Graph-1

Day with Accident_Severity

Observation: Fatal data is too less to be seen in the graph

Graph-1.1

Different graph for Fatal case

Graph-2

Month with Accident_Severity

Observation: Fatal data is too less to be seen in the graph

Graph-2.1

Different graph for Fatal case

Task-3: Get Seasonal Data from Months

Observations:

⬆️TOP⬆️

Feature: Accident_Severity
Observations:

⬆️TOP⬆️

Feature: Day_of_Week
Observations:

⬆️TOP⬆️

Feature: Time

Task-1: Converting Time feature from object to datetime

Extract hour from Time data

Observations:

⬆️TOP⬆️

Feature: Junction_Control
Observations:

Auto traffic signal and Auto traffic sigl may be same just misspelled

Observations:

⬆️TOP⬆️

Feature: Junction_Detail
Observations:

⬆️TOP⬆️

Feature: Light_Conditions
Observations:

⬆️TOP⬆️

Feature: Weather_Conditions
Observations:

⬆️TOP⬆️

Feature: Number_of_Casualties
Observations:

⬆️TOP⬆️

Feature: Number_of_Vehicles
Observations:

⬆️TOP⬆️

Feature: Road_Type
Observations:

⬆️TOP⬆️

Feature: Road_Surface_Conditions
Observations:

⬆️TOP⬆️

Feature: Special_Conditions_at_Site
Observations:

⬆️TOP⬆️

Feature: Urban_or_Rural_Area

⬆️TOP⬆️

Feature: Police_Force

Part-2: Bivariate Analysis

⬆️TOP⬆️

Contents:

Data Preprocessing before analysis:

  1. Fill/drop null values
  2. Convert object to numeric values

1. Fill/drop null/less important values

Drop:

Find numeric columns that have null values

Convert Object to Category

Heatmap for correlation

Clustermap with dendogram

Part-3: Multivariate Analysis

⬆️TOP⬆️

Contents: